Pandas Profiling Report

Dataset statistics

Number of variables	27
Number of observations	355
Missing cells	2
Missing cells (%)	< 0.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	75.0 KiB
Average record size in memory	216.4 B

Variable types

Numeric	21
Categorical	6

Alerts

`season` has constant value "Pre-monsoon 2020"	Constant
`mandal` has a high cardinality: 299 distinct values	High cardinality
`village` has a high cardinality: 350 distinct values	High cardinality
`sno` is highly correlated with `district` and 3 other fields	High correlation
`temp_id` is highly correlated with `sno` and 2 other fields	High correlation
`pH` is highly correlated with `district` and 5 other fields	High correlation
`E.C` is highly correlated with `TDS` and 11 other fields	High correlation
`TDS` is highly correlated with `E.C` and 11 other fields	High correlation
`CO3` is highly correlated with `pH`	High correlation
`HCO3` is highly correlated with `pH` and 7 other fields	High correlation
`Cl` is highly correlated with `E.C` and 10 other fields	High correlation
`NO3` is highly correlated with `E.C` and 8 other fields	High correlation
`SO4` is highly correlated with `E.C` and 9 other fields	High correlation
`Na` is highly correlated with `E.C` and 11 other fields	High correlation
`Ca` is highly correlated with `E.C` and 6 other fields	High correlation
`Mg` is highly correlated with `E.C` and 9 other fields	High correlation
`T.H` is highly correlated with `E.C` and 9 other fields	High correlation
`SAR` is highly correlated with `E.C` and 9 other fields	High correlation
`RSC meq / L` is highly correlated with `pH` and 14 other fields	High correlation
`season` is highly correlated with `Classification` and 2 other fields	High correlation
`Classification` is highly correlated with `pH` and 13 other fields	High correlation
`district` is highly correlated with `sno` and 6 other fields	High correlation
`Classification.1` is highly correlated with `district` and 3 other fields	High correlation
`long_gis` is highly correlated with `sno` and 2 other fields	High correlation
`lat_gis` is highly correlated with `sno` and 1 other fields	High correlation
`gwl` is highly correlated with `district`	High correlation
`F` is highly correlated with `pH` and 6 other fields	High correlation
`mandal` is uniformly distributed	Uniform
`village` is uniformly distributed	Uniform
`sno` has unique values	Unique
`temp_id` has unique values	Unique
`CO3` has 292 (82.3%) zeros	Zeros

Reproduction

Analysis started	2023-08-10 11:46:19.437144
Analysis finished	2023-08-10 11:53:17.223752
Duration	6 minutes and 57.79 seconds
Software version	pandas-profiling v3.3.0
Download configuration	config.json

sno
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	355
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	192.3211268

Minimum	1
Maximum	379
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.9 KiB

Quantile statistics

Minimum	1
5-th percentile	19.7
Q1	91.5
median	193
Q3	289.5
95-th percentile	361.3
Maximum	379
Range	378
Interquartile range (IQR)	198

Descriptive statistics

Standard deviation	111.156852
Coefficient of variation (CV)	0.5779752534
Kurtosis	-1.231229045
Mean	192.3211268
Median Absolute Deviation (MAD)	99
Skewness	-0.0362315332
Sum	68274
Variance	12355.84574
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
379	1	0.3%
91	1	0.3%
124	1	0.3%
125	1	0.3%
126	1	0.3%
127	1	0.3%
128	1	0.3%
129	1	0.3%
130	1	0.3%
131	1	0.3%
Other values (345)	345	97.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	0.3%
2	1	0.3%
3	1	0.3%
4	1	0.3%
5	1	0.3%
6	1	0.3%
7	1	0.3%
8	1	0.3%
9	1	0.3%
10	1	0.3%

Value	Count	Frequency (%)
379	1	0.3%
378	1	0.3%
377	1	0.3%
376	1	0.3%
375	1	0.3%
374	1	0.3%
373	1	0.3%
372	1	0.3%
371	1	0.3%
370	1	0.3%

district
Categorical

HIGH CORRELATION

Distinct	33
Distinct (%)	9.3%
Missing	0
Missing (%)	0.0%
Memory size	2.9 KiB

NALGONDA	33
NIZAMABAD	23
KAMAREDDY	21
MEDAK	17
RANGAREDDY	17
Other values (28)	244

Length

Max length	17
Median length	12
Mean length	9.205633803
Min length	5

Characters and Unicode

Total characters	3268
Distinct characters	26
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ADILABAD
2nd row	ADILABAD
3rd row	ADILABAD
4th row	ADILABAD
5th row	ADILABAD

Common Values

Value	Count	Frequency (%)
NALGONDA	33	9.3%
NIZAMABAD	23	6.5%
KAMAREDDY	21	5.9%
MEDAK	17	4.8%
RANGAREDDY	17	4.8%
VIKARABAD	16	4.5%
YADADRI	15	4.2%
BHADRADRI	14	3.9%
JAGITYAL	14	3.9%
MAHABUBNAGAR	12	3.4%
Other values (23)	173	48.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
nalgonda	33	8.7%
nizamabad	23	6.1%
kamareddy	21	5.5%
warangal	18	4.7%
medak	17	4.5%
rangareddy	17	4.5%
vikarabad	16	4.2%
yadadri	15	4.0%
jagityal	14	3.7%
bhadradri	14	3.7%
Other values (25)	191	50.4%

Most occurring characters

Value	Count	Frequency (%)
A	782	23.9%
D	328	10.0%
R	258	7.9%
N	231	7.1%
L	170	5.2%
M	161	4.9%
G	153	4.7%
I	141	4.3%
B	138	4.2%
E	127	3.9%
Other values (16)	779	23.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	3175	97.2%
Space Separator	35	1.1%
Open Punctuation	29	0.9%
Close Punctuation	29	0.9%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	782	24.6%
D	328	10.3%
R	258	8.1%
N	231	7.3%
L	170	5.4%
M	161	5.1%
G	153	4.8%
I	141	4.4%
B	138	4.3%
E	127	4.0%
Other values (13)	686	21.6%

Space Separator

Value	Count	Frequency (%)
	35	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	29	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	29	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3175	97.2%
Common	93	2.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	782	24.6%
D	328	10.3%
R	258	8.1%
N	231	7.3%
L	170	5.4%
M	161	5.1%
G	153	4.8%
I	141	4.4%
B	138	4.3%
E	127	4.0%
Other values (13)	686	21.6%

Common

Value	Count	Frequency (%)
	35	37.6%
(	29	31.2%
)	29	31.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3268	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	782	23.9%
D	328	10.0%
R	258	7.9%
N	231	7.1%
L	170	5.2%
M	161	4.9%
G	153	4.7%
I	141	4.3%
B	138	4.2%
E	127	3.9%
Other values (16)	779	23.8%

mandal
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	299
Distinct (%)	84.2%
Missing	0
Missing (%)	0.0%
Memory size	2.9 KiB

Rajapet	4
Chandur	4
Anumula	4
Nakrekal	3
Nandipet	3
Other values (294)	337

Length

Max length	18
Median length	16
Mean length	8.861971831
Min length	4

Characters and Unicode

Total characters	3146
Distinct characters	54
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	257 ?
Unique (%)	72.4%

Sample

1st row	Adilabad
2nd row	Bazarhatnur
3rd row	Gudihatnoor
4th row	Jainath
5th row	Narnoor

Common Values

Value	Count	Frequency (%)
Rajapet	4	1.1%
Chandur	4	1.1%
Anumula	4	1.1%
Nakrekal	3	0.8%
Nandipet	3	0.8%
Nalgonda	3	0.8%
Narayanpet	3	0.8%
Dharoor	3	0.8%
Qutubullapur	3	0.8%
Shivampet	3	0.8%
Other values (289)	322	90.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
rajapet	4	1.1%
chandur	4	1.1%
anumula	4	1.1%
dharoor	3	0.8%
ghanpur	3	0.8%
kunta	3	0.8%
cc	3	0.8%
qutubullapur	3	0.8%
shivampet	3	0.8%
narayanpet	3	0.8%
Other values (294)	334	91.0%

Most occurring characters

Value	Count	Frequency (%)
a	626	19.9%
l	225	7.2%
r	223	7.1%
u	168	5.3%
n	165	5.2%
d	162	5.1%
e	142	4.5%
p	135	4.3%
i	135	4.3%
h	113	3.6%
Other values (44)	1052	33.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2720	86.5%
Uppercase Letter	394	12.5%
Space Separator	17	0.5%
Other Punctuation	7	0.2%
Open Punctuation	3	0.1%
Close Punctuation	3	0.1%
Dash Punctuation	2	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	626	23.0%
l	225	8.3%
r	223	8.2%
u	168	6.2%
n	165	6.1%
d	162	6.0%
e	142	5.2%
p	135	5.0%
i	135	5.0%
h	113	4.2%
Other values (15)	626	23.0%

Uppercase Letter

Value	Count	Frequency (%)
K	49	12.4%
M	41	10.4%
N	38	9.6%
A	26	6.6%
B	24	6.1%
T	23	5.8%
C	23	5.8%
D	22	5.6%
G	20	5.1%
P	20	5.1%
Other values (14)	108	27.4%

Space Separator

Value	Count	Frequency (%)
	17	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	7	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	3	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	3	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3114	99.0%
Common	32	1.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	626	20.1%
l	225	7.2%
r	223	7.2%
u	168	5.4%
n	165	5.3%
d	162	5.2%
e	142	4.6%
p	135	4.3%
i	135	4.3%
h	113	3.6%
Other values (39)	1020	32.8%

Common

Value	Count	Frequency (%)
	17	53.1%
.	7	21.9%
(	3	9.4%
)	3	9.4%
-	2	6.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3146	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	626	19.9%
l	225	7.2%
r	223	7.1%
u	168	5.3%
n	165	5.2%
d	162	5.1%
e	142	4.5%
p	135	4.3%
i	135	4.3%
h	113	3.6%
Other values (44)	1052	33.4%

village
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	350
Distinct (%)	98.6%
Missing	0
Missing (%)	0.0%
Memory size	2.9 KiB

Angadipet	2
Dharoor	2
Kodur	2
Khanapur	2
Kanchanapalli	2
Other values (345)	345

Length

Max length	21
Median length	16
Mean length	9.38028169
Min length	4

Characters and Unicode

Total characters	3330
Distinct characters	56
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	345 ?
Unique (%)	97.2%

Sample

1st row	Adilabad
2nd row	Bazarhatnur
3rd row	Gudihatnoor
4th row	Jainath
5th row	Narnoor

Common Values

Value	Count	Frequency (%)
Angadipet	2	0.6%
Dharoor	2	0.6%
Kodur	2	0.6%
Khanapur	2	0.6%
Kanchanapalli	2	0.6%
Papannapet	1	0.3%
Yanampally	1	0.3%
Maheswaram	1	0.3%
Narketpalli	1	0.3%
Narasapur	1	0.3%
Other values (340)	340	95.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
i	3	0.8%
angadipet	2	0.5%
nagar	2	0.5%
b	2	0.5%
tandur	2	0.5%
s	2	0.5%
somaram	2	0.5%
2	2	0.5%
nagaram	2	0.5%
1	2	0.5%
Other values (359)	363	94.5%

Most occurring characters

Value	Count	Frequency (%)
a	683	20.5%
l	272	8.2%
r	230	6.9%
u	175	5.3%
n	162	4.9%
p	159	4.8%
d	142	4.3%
e	140	4.2%
i	137	4.1%
m	128	3.8%
Other values (46)	1102	33.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2870	86.2%
Uppercase Letter	392	11.8%
Space Separator	31	0.9%
Other Punctuation	12	0.4%
Close Punctuation	9	0.3%
Open Punctuation	9	0.3%
Decimal Number	7	0.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	683	23.8%
l	272	9.5%
r	230	8.0%
u	175	6.1%
n	162	5.6%
p	159	5.5%
d	142	4.9%
e	140	4.9%
i	137	4.8%
m	128	4.5%
Other values (15)	642	22.4%

Uppercase Letter

Value	Count	Frequency (%)
K	45	11.5%
M	45	11.5%
B	32	8.2%
N	30	7.7%
A	29	7.4%
S	26	6.6%
R	24	6.1%
P	23	5.9%
D	21	5.4%
G	19	4.8%
Other values (14)	98	25.0%

Decimal Number

Value	Count	Frequency (%)
1	3	42.9%
2	3	42.9%
5	1	14.3%

Space Separator

Value	Count	Frequency (%)
	31	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	12	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	9	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	9	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3262	98.0%
Common	68	2.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	683	20.9%
l	272	8.3%
r	230	7.1%
u	175	5.4%
n	162	5.0%
p	159	4.9%
d	142	4.4%
e	140	4.3%
i	137	4.2%
m	128	3.9%
Other values (39)	1034	31.7%

Common

Value	Count	Frequency (%)
	31	45.6%
.	12	17.6%
)	9	13.2%
(	9	13.2%
1	3	4.4%
2	3	4.4%
5	1	1.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3330	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	683	20.5%
l	272	8.2%
r	230	6.9%
u	175	5.3%
n	162	4.9%
p	159	4.8%
d	142	4.3%
e	140	4.2%
i	137	4.1%
m	128	3.8%
Other values (46)	1102	33.1%

temp_id
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	355
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1506.867606

Minimum	1001
Maximum	4012
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.9 KiB

Quantile statistics

Minimum	1001
5-th percentile	1055.5
Q1	1232.5
median	1452
Q3	1670.5
95-th percentile	1877.9
Maximum	4012
Range	3011
Interquartile range (IQR)	438

Descriptive statistics

Standard deviation	404.8700942
Coefficient of variation (CV)	0.2686832557
Kurtosis	8.834322484
Mean	1506.867606
Median Absolute Deviation (MAD)	220
Skewness	2.415834993
Sum	534938
Variance	163919.7932
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1022	1	0.3%
1132	1	0.3%
1170	1	0.3%
1171	1	0.3%
1172	1	0.3%
1174	1	0.3%
1175	1	0.3%
1688	1	0.3%
1177	1	0.3%
1178	1	0.3%
Other values (345)	345	97.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1001	1	0.3%
1002	1	0.3%
1007	1	0.3%
1009	1	0.3%
1010	1	0.3%
1011	1	0.3%
1013	1	0.3%
1014	1	0.3%
1015	1	0.3%
1021	1	0.3%

Value	Count	Frequency (%)
4012	1	0.3%
3137	1	0.3%
3117	1	0.3%
3088	1	0.3%
3041	1	0.3%
3040	1	0.3%
3036	1	0.3%
3035	1	0.3%
3034	1	0.3%
3029	1	0.3%

long_gis
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	353
Distinct (%)	99.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	78.74924306

Minimum	77.444
Maximum	80.900922
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.9 KiB

Quantile statistics

Minimum	77.444
5-th percentile	77.65529
Q1	78.1485
median	78.552568
Q3	79.290817
95-th percentile	80.2030223
Maximum	80.900922
Range	3.456922
Interquartile range (IQR)	1.142317

Descriptive statistics

Standard deviation	0.7799561757
Coefficient of variation (CV)	0.009904300605
Kurtosis	-0.2937252792
Mean	78.74924306
Median Absolute Deviation (MAD)	0.528968
Skewness	0.588555076
Sum	27955.98129
Variance	0.608331636
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
78.508	2	0.6%
78.114	2	0.6%
80.45	1	0.3%
78.493	1	0.3%
79.008888	1	0.3%
78.0899	1	0.3%
79.7324	1	0.3%
78.405	1	0.3%
78.3194	1	0.3%
79.5153	1	0.3%
Other values (343)	343	96.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
77.444	1	0.3%
77.4812	1	0.3%
77.500096	1	0.3%
77.5003	1	0.3%
77.511	1	0.3%
77.516956	1	0.3%
77.526	1	0.3%
77.5415	1	0.3%
77.5757	1	0.3%
77.591	1	0.3%

Value	Count	Frequency (%)
80.900922	1	0.3%
80.826104	1	0.3%
80.809241	1	0.3%
80.7911	1	0.3%
80.73	1	0.3%
80.619	1	0.3%
80.6106	1	0.3%
80.58	1	0.3%
80.568147	1	0.3%
80.520318	1	0.3%

lat_gis
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	351
Distinct (%)	98.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17.72078925

Minimum	15.896441
Maximum	19.730555
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.9 KiB

Quantile statistics

Minimum	15.896441
5-th percentile	16.3352381
Q1	17.121656
median	17.6713
Q3	18.372871
95-th percentile	19.1451079
Maximum	19.730555
Range	3.834114
Interquartile range (IQR)	1.251215

Descriptive statistics

Standard deviation	0.8663571857
Coefficient of variation (CV)	0.04888931151
Kurtosis	-0.7095312428
Mean	17.72078925
Median Absolute Deviation (MAD)	0.630491
Skewness	0.1361186979
Sum	6290.880182
Variance	0.7505747732
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17.54	2	0.6%
17.445	2	0.6%
17.33	2	0.6%
17.47	2	0.6%
18.5334	1	0.3%
16.716555	1	0.3%
17.141752	1	0.3%
17.8081	1	0.3%
17.164004	1	0.3%
17.744466	1	0.3%
Other values (341)	341	96.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
15.896441	1	0.3%
15.94	1	0.3%
15.9656	1	0.3%
16.01518	1	0.3%
16.0701	1	0.3%
16.107	1	0.3%
16.1156	1	0.3%
16.1287	1	0.3%
16.129667	1	0.3%
16.179	1	0.3%

Value	Count	Frequency (%)
19.730555	1	0.3%
19.6811	1	0.3%
19.6683	1	0.3%
19.6334	1	0.3%
19.525555	1	0.3%
19.5219	1	0.3%
19.495665	1	0.3%
19.458888	1	0.3%
19.444	1	0.3%
19.3789	1	0.3%

gwl
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	317
Distinct (%)	89.8%
Missing	2
Missing (%)	0.6%
Infinite	0
Infinite (%)	0.0%
Mean	11.98929178

Minimum	1.4
Maximum	49.11
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.9 KiB

Quantile statistics

Minimum	1.4
5-th percentile	3.412
Q1	6.2
median	9.88
Q3	15.99
95-th percentile	26.584
Maximum	49.11
Range	47.71
Interquartile range (IQR)	9.79

Descriptive statistics

Standard deviation	7.644774902
Coefficient of variation (CV)	0.6376335683
Kurtosis	1.792561066
Mean	11.98929178
Median Absolute Deviation (MAD)	4.58
Skewness	1.223668934
Sum	4232.22
Variance	58.4425833
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.9	4	1.1%
16.5	3	0.8%
9.9	3	0.8%
4.5	3	0.8%
8	3	0.8%
18.1	3	0.8%
7.38	3	0.8%
9.43	2	0.6%
6.8	2	0.6%
12.67	2	0.6%
Other values (307)	325	91.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.4	1	0.3%
1.55	1	0.3%
1.7	1	0.3%
1.76	1	0.3%
2.17	1	0.3%
2.22	1	0.3%
2.27	1	0.3%
2.43	1	0.3%
2.47	1	0.3%
2.57	1	0.3%

Value	Count	Frequency (%)
49.11	1	0.3%
39.1	1	0.3%
37.8	1	0.3%
33.82	1	0.3%
33	2	0.6%
32	1	0.3%
31.43	1	0.3%
31.3	1	0.3%
31.2	1	0.3%
29.37	1	0.3%

season
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	2.9 KiB

Pre-monsoon 2020	355

Length

Max length	16
Median length	16
Mean length	16
Min length	16

Characters and Unicode

Total characters	5680
Distinct characters	11
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Pre-monsoon 2020
2nd row	Pre-monsoon 2020
3rd row	Pre-monsoon 2020
4th row	Pre-monsoon 2020
5th row	Pre-monsoon 2020

Common Values

Value	Count	Frequency (%)
Pre-monsoon 2020	355	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
2020	355	50.0%
pre-monsoon	355	50.0%

Most occurring characters

Value	Count	Frequency (%)
o	1065	18.8%
0	710	12.5%
2	710	12.5%
n	710	12.5%
	355	6.2%
s	355	6.2%
m	355	6.2%
-	355	6.2%
e	355	6.2%
r	355	6.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3195	56.2%
Decimal Number	1420	25.0%
Space Separator	355	6.2%
Dash Punctuation	355	6.2%
Uppercase Letter	355	6.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	1065	33.3%
n	710	22.2%
s	355	11.1%
m	355	11.1%
e	355	11.1%
r	355	11.1%

Decimal Number

Value	Count	Frequency (%)
0	710	50.0%
2	710	50.0%

Space Separator

Value	Count	Frequency (%)
	355	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	355	100.0%

Uppercase Letter

Value	Count	Frequency (%)
P	355	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3550	62.5%
Common	2130	37.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	1065	30.0%
n	710	20.0%
s	355	10.0%
m	355	10.0%
e	355	10.0%
r	355	10.0%
P	355	10.0%

Common

Value	Count	Frequency (%)
0	710	33.3%
2	710	33.3%
	355	16.7%
-	355	16.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5680	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	1065	18.8%
0	710	12.5%
2	710	12.5%
n	710	12.5%
	355	6.2%
s	355	6.2%
m	355	6.2%
-	355	6.2%
e	355	6.2%
r	355	6.2%

pH
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	137
Distinct (%)	38.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.008535211

Minimum	7.02
Maximum	9.37
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.9 KiB

Quantile statistics

Minimum	7.02
5-th percentile	7.4
Q1	7.76
median	7.99
Q3	8.24
95-th percentile	8.703
Maximum	9.37
Range	2.35
Interquartile range (IQR)	0.48

Descriptive statistics

Standard deviation	0.3814921577
Coefficient of variation (CV)	0.04763569712
Kurtosis	0.6526393318
Mean	8.008535211
Median Absolute Deviation (MAD)	0.24
Skewness	0.4338681303
Sum	2843.03
Variance	0.1455362664
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7.99	10	2.8%
7.94	8	2.3%
8.09	8	2.3%
8.28	8	2.3%
8.04	7	2.0%
7.81	7	2.0%
8.22	6	1.7%
8.23	6	1.7%
7.76	6	1.7%
7.66	6	1.7%
Other values (127)	283	79.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
7.02	1	0.3%
7.17	1	0.3%
7.22	1	0.3%
7.26	2	0.6%
7.27	1	0.3%
7.29	2	0.6%
7.32	2	0.6%
7.33	1	0.3%
7.35	1	0.3%
7.38	1	0.3%

Value	Count	Frequency (%)
9.37	1	0.3%
9.32	1	0.3%
9.17	1	0.3%
9.1	1	0.3%
9.08	1	0.3%
9.06	1	0.3%
8.87	1	0.3%
8.85	1	0.3%
8.84	1	0.3%
8.83	1	0.3%

E.C
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	322
Distinct (%)	90.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1268.96507

Minimum	102
Maximum	5175
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.9 KiB

Quantile statistics

Minimum	102
5-th percentile	446.9
Q1	768
median	1085
Q3	1590
95-th percentile	2550
Maximum	5175
Range	5073
Interquartile range (IQR)	822

Descriptive statistics

Standard deviation	746.1916204
Coefficient of variation (CV)	0.588031647
Kurtosis	5.59178293
Mean	1268.96507
Median Absolute Deviation (MAD)	368
Skewness	1.93260619
Sum	450482.6
Variance	556801.9343
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
788	3	0.8%
1025	2	0.6%
979	2	0.6%
779	2	0.6%
1302	2	0.6%
1080	2	0.6%
828	2	0.6%
1408	2	0.6%
1479	2	0.6%
695	2	0.6%
Other values (312)	334	94.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
102	1	0.3%
111	1	0.3%
250	1	0.3%
306	1	0.3%
316	1	0.3%
350	1	0.3%
367	1	0.3%
382	2	0.6%
391	1	0.3%
404	1	0.3%

Value	Count	Frequency (%)
5175	1	0.3%
4878	1	0.3%
4429	1	0.3%
4377	1	0.3%
4264	1	0.3%
3961	1	0.3%
3717	1	0.3%
3553	1	0.3%
3189	1	0.3%
3171	1	0.3%

TDS
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	322
Distinct (%)	90.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	812.1376451

Minimum	65.28
Maximum	3312
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.9 KiB

Quantile statistics

Minimum	65.28
5-th percentile	286.016
Q1	491.52
median	694.4
Q3	1017.6
95-th percentile	1632
Maximum	3312
Range	3246.72
Interquartile range (IQR)	526.08

Descriptive statistics

Standard deviation	477.562637
Coefficient of variation (CV)	0.588031647
Kurtosis	5.59178293
Mean	812.1376451
Median Absolute Deviation (MAD)	235.52
Skewness	1.93260619
Sum	288308.864
Variance	228066.0723
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
504.32	3	0.8%
491.52	2	0.6%
1017.6	2	0.6%
516.48	2	0.6%
403.2	2	0.6%
1687.04	2	0.6%
624.64	2	0.6%
946.56	2	0.6%
833.28	2	0.6%
901.12	2	0.6%
Other values (312)	334	94.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
65.28	1	0.3%
71.04	1	0.3%
160	1	0.3%
195.84	1	0.3%
202.24	1	0.3%
224	1	0.3%
234.88	1	0.3%
244.48	2	0.6%
250.24	1	0.3%
258.56	1	0.3%

Value	Count	Frequency (%)
3312	1	0.3%
3121.92	1	0.3%
2834.56	1	0.3%
2801.28	1	0.3%
2728.96	1	0.3%
2535.04	1	0.3%
2378.88	1	0.3%
2273.92	1	0.3%
2040.96	1	0.3%
2029.44	1	0.3%

CO3
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	8
Distinct (%)	2.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.126760563

Minimum	0
Maximum	80
Zeros	292
Zeros (%)	82.3%
Negative	0
Negative (%)	0.0%
Memory size	2.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	30
Maximum	80
Range	80
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	12.82975177
Coefficient of variation (CV)	2.502506526
Kurtosis	9.210898281
Mean	5.126760563
Median Absolute Deviation (MAD)	0
Skewness	2.90564428
Sum	1820
Variance	164.6025304
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
0	292	82.3%
20	20	5.6%
30	16	4.5%
10	10	2.8%
40	8	2.3%
50	6	1.7%
80	2	0.6%
60	1	0.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	292	82.3%
10	10	2.8%
20	20	5.6%
30	16	4.5%
40	8	2.3%
50	6	1.7%
60	1	0.3%
80	2	0.6%

Value	Count	Frequency (%)
80	2	0.6%
60	1	0.3%
50	6	1.7%
40	8	2.3%
30	16	4.5%
20	20	5.6%
10	10	2.8%
0	292	82.3%

HCO3
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	56
Distinct (%)	15.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	279.4366197

Minimum	20
Maximum	950
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.9 KiB

Quantile statistics

Minimum	20
5-th percentile	107
Q1	190
median	270
Q3	350
95-th percentile	490
Maximum	950
Range	930
Interquartile range (IQR)	160

Descriptive statistics

Standard deviation	123.4449868
Coefficient of variation (CV)	0.4417638135
Kurtosis	2.60966778
Mean	279.4366197
Median Absolute Deviation (MAD)	80
Skewness	0.9673932529
Sum	99200
Variance	15238.66476
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
290	17	4.8%
180	17	4.8%
300	17	4.8%
230	15	4.2%
260	14	3.9%
220	13	3.7%
330	13	3.7%
130	12	3.4%
350	12	3.4%
360	11	3.1%
Other values (46)	214	60.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20	1	0.3%
30	1	0.3%
70	1	0.3%
80	2	0.6%
90	5	1.4%
100	8	2.3%
110	4	1.1%
120	11	3.1%
130	12	3.4%
140	4	1.1%

Value	Count	Frequency (%)
950	1	0.3%
810	1	0.3%
620	1	0.3%
590	2	0.6%
580	1	0.3%
570	2	0.6%
550	3	0.8%
530	2	0.6%
520	1	0.3%
510	1	0.3%

Cl
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	65
Distinct (%)	18.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	193.0704225

Minimum	10
Maximum	1380
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.9 KiB

Quantile statistics

Minimum	10
5-th percentile	30
Q1	70
median	140
Q3	250
95-th percentile	530
Maximum	1380
Range	1370
Interquartile range (IQR)	180

Descriptive statistics

Standard deviation	185.593819
Coefficient of variation (CV)	0.9612752516
Kurtosis	8.85304929
Mean	193.0704225
Median Absolute Deviation (MAD)	80
Skewness	2.51784931
Sum	68540
Variance	34445.06565
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
60	21	5.9%
70	20	5.6%
50	16	4.5%
30	15	4.2%
40	15	4.2%
80	14	3.9%
120	13	3.7%
110	13	3.7%
90	13	3.7%
220	12	3.4%
Other values (55)	203	57.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10	2	0.6%
20	11	3.1%
30	15	4.2%
40	15	4.2%
50	16	4.5%
60	21	5.9%
70	20	5.6%
80	14	3.9%
90	13	3.7%
100	10	2.8%

Value	Count	Frequency (%)
1380	1	0.3%
1010	2	0.6%
980	1	0.3%
960	1	0.3%
950	1	0.3%
890	1	0.3%
820	1	0.3%
760	1	0.3%
740	1	0.3%
670	1	0.3%

F
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	189
Distinct (%)	53.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.106915493

Minimum	0.04
Maximum	4.78
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.9 KiB

Quantile statistics

Minimum	0.04
5-th percentile	0.28
Q1	0.6
median	0.89
Q3	1.44
95-th percentile	2.427
Maximum	4.78
Range	4.74
Interquartile range (IQR)	0.84

Descriptive statistics

Standard deviation	0.746359616
Coefficient of variation (CV)	0.6742697349
Kurtosis	3.568141594
Mean	1.106915493
Median Absolute Deviation (MAD)	0.35
Skewness	1.608064789
Sum	392.955
Variance	0.5570526765
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.62	8	2.3%
0.45	6	1.7%
0.89	5	1.4%
0.72	5	1.4%
1.05	5	1.4%
0.59	5	1.4%
0.61	5	1.4%
0.83	5	1.4%
0.79	4	1.1%
0.56	4	1.1%
Other values (179)	303	85.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.04	1	0.3%
0.115	1	0.3%
0.14	1	0.3%
0.147	1	0.3%
0.18	2	0.6%
0.19	1	0.3%
0.2	3	0.8%
0.21	1	0.3%
0.23	2	0.6%
0.257	1	0.3%

Value	Count	Frequency (%)
4.78	1	0.3%
4.57	1	0.3%
4.23	1	0.3%
3.64	1	0.3%
3.39	1	0.3%
3.26	1	0.3%
3.19	1	0.3%
3.17	1	0.3%
3.15	1	0.3%
3.11	1	0.3%

NO3
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	321
Distinct (%)	90.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	60.0777023

Minimum	0.026574
Maximum	456.187
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.9 KiB

Quantile statistics

Minimum	0.026574
5-th percentile	1.786497545
Q1	15.262334
median	35.432
Q3	71.57264
95-th percentile	211.66191
Maximum	456.187
Range	456.160426
Interquartile range (IQR)	56.310306

Descriptive statistics

Standard deviation	74.76762315
Coefficient of variation (CV)	1.244515358
Kurtosis	9.195300736
Mean	60.0777023
Median Absolute Deviation (MAD)	21.7021
Skewness	2.700478631
Sum	21327.58431
Variance	5590.197472
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
35.432	4	1.1%
13.7299	3	0.8%
19.66476	3	0.8%
0.805272727	3	0.8%
44.08868182	2	0.6%
14.70428	2	0.6%
47.8332	2	0.6%
25.2453	2	0.6%
7.650090909	2	0.6%
90.7945	2	0.6%
Other values (311)	330	93.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.026574	1	0.3%
0.048719	1	0.3%
0.17716	1	0.3%
0.26574	1	0.3%
0.314459	1	0.3%
0.35432	1	0.3%
0.402636364	1	0.3%
0.805272727	3	0.8%
1.06296	1	0.3%
1.10725	1	0.3%

Value	Count	Frequency (%)
456.187	1	0.3%
451.758	1	0.3%
446.53178	1	0.3%
436.6994	1	0.3%
414.1115	1	0.3%
326.90449	1	0.3%
301.172	1	0.3%
298.9575	1	0.3%
297.6288	1	0.3%
244.79083	1	0.3%

SO4
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	145
Distinct (%)	40.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	25.67191549

Minimum	3.75
Maximum	440
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.9 KiB

Quantile statistics

Minimum	3.75
5-th percentile	8
Q1	13
median	20
Q3	29.5
95-th percentile	56.6
Maximum	440
Range	436.25
Interquartile range (IQR)	16.5

Descriptive statistics

Standard deviation	29.58777029
Coefficient of variation (CV)	1.152534578
Kurtosis	111.620464
Mean	25.67191549
Median Absolute Deviation (MAD)	7.75
Skewness	8.79599765
Sum	9113.53
Variance	875.4361506
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
19	14	3.9%
20	14	3.9%
13	13	3.7%
24	11	3.1%
23	11	3.1%
14	10	2.8%
12	10	2.8%
10	10	2.8%
22	9	2.5%
9	8	2.3%
Other values (135)	245	69.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3.75	1	0.3%
4.25	1	0.3%
4.5	1	0.3%
5	2	0.6%
5.95	1	0.3%
6	1	0.3%
7	5	1.4%
7.25	1	0.3%
7.45	1	0.3%
7.75	1	0.3%

Value	Count	Frequency (%)
440	1	0.3%
180	1	0.3%
158	1	0.3%
107.29	1	0.3%
105	1	0.3%
98.5	1	0.3%
98	1	0.3%
96	1	0.3%
94	1	0.3%
86	1	0.3%

Na
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	258
Distinct (%)	72.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	116.808507

Minimum	6.4
Maximum	712
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.9 KiB

Quantile statistics

Minimum	6.4
5-th percentile	26.472
Q1	55.16
median	88.18
Q3	147.5
95-th percentile	312.7
Maximum	712
Range	705.6
Interquartile range (IQR)	92.34

Descriptive statistics

Standard deviation	100.1166613
Coefficient of variation (CV)	0.85710077
Kurtosis	7.817124734
Mean	116.808507
Median Absolute Deviation (MAD)	37.44
Skewness	2.407638212
Sum	41467.02
Variance	10023.34588
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
31	6	1.7%
62	6	1.7%
72	5	1.4%
60	5	1.4%
29	5	1.4%
115	5	1.4%
55	5	1.4%
61	4	1.1%
69	4	1.1%
112	4	1.1%
Other values (248)	306	86.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6.4	1	0.3%
10	1	0.3%
12	2	0.6%
16	2	0.6%
17	1	0.3%
17.58	1	0.3%
19	1	0.3%
20	2	0.6%
20.9	1	0.3%
21	1	0.3%

Value	Count	Frequency (%)
712	1	0.3%
623	1	0.3%
535	1	0.3%
532	1	0.3%
515	1	0.3%
511	1	0.3%
486	1	0.3%
458.2	1	0.3%
402.6	1	0.3%
381.2	1	0.3%

K
Real number (ℝ_≥0)

Distinct	192
Distinct (%)	54.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.141746479

Minimum	0.18
Maximum	95.8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.9 KiB

Quantile statistics

Minimum	0.18
5-th percentile	0.931
Q1	2
median	3
Q3	5
95-th percentile	20.615
Maximum	95.8
Range	95.62
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	11.17139867
Coefficient of variation (CV)	1.818928657
Kurtosis	32.67070318
Mean	6.141746479
Median Absolute Deviation (MAD)	1.27
Skewness	5.23879333
Sum	2180.32
Variance	124.8001484
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	30	8.5%
3	23	6.5%
1	19	5.4%
4	19	5.4%
5	12	3.4%
6	6	1.7%
12	5	1.4%
2.5	4	1.1%
3.4	4	1.1%
3.9	4	1.1%
Other values (182)	229	64.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.18	1	0.3%
0.2	1	0.3%
0.24	1	0.3%
0.34	1	0.3%
0.49	2	0.6%
0.56	2	0.6%
0.6	3	0.8%
0.62	1	0.3%
0.63	1	0.3%
0.68	2	0.6%

Value	Count	Frequency (%)
95.8	1	0.3%
89.18	1	0.3%
89	1	0.3%
66.61	1	0.3%
63.3	1	0.3%
46.11	1	0.3%
44.4	1	0.3%
43	1	0.3%
37.5	1	0.3%
36.9	1	0.3%

Ca
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	30
Distinct (%)	8.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	73.21690141

Minimum	8
Maximum	488
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.9 KiB

Quantile statistics

Minimum	8
5-th percentile	16
Q1	40
median	64
Q3	88
95-th percentile	176
Maximum	488
Range	480
Interquartile range (IQR)	48

Descriptive statistics

Standard deviation	53.44922874
Coefficient of variation (CV)	0.7300121653
Kurtosis	13.72567688
Mean	73.21690141
Median Absolute Deviation (MAD)	24
Skewness	2.676409489
Sum	25992
Variance	2856.820053
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=30)

Value	Count	Frequency (%)
40	44	12.4%
56	32	9.0%
64	30	8.5%
32	26	7.3%
80	26	7.3%
24	25	7.0%
72	24	6.8%
48	20	5.6%
16	18	5.1%
88	18	5.1%
Other values (20)	92	25.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
8	6	1.7%
16	18	5.1%
24	25	7.0%
32	26	7.3%
40	44	12.4%
48	20	5.6%
56	32	9.0%
64	30	8.5%
72	24	6.8%
80	26	7.3%

Value	Count	Frequency (%)
488	1	0.3%
400	1	0.3%
264	1	0.3%
216	1	0.3%
208	3	0.8%
200	3	0.8%
192	3	0.8%
184	4	1.1%
176	5	1.4%
168	2	0.6%

Mg
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	36
Distinct (%)	10.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	49.77355493

Minimum	4.862
Maximum	233.376
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.9 KiB

Quantile statistics

Minimum	4.862
5-th percentile	13.1274
Q1	24.31
median	43.758
Q3	63.206
95-th percentile	116.688
Maximum	233.376
Range	228.514
Interquartile range (IQR)	38.896

Descriptive statistics

Standard deviation	34.77078556
Coefficient of variation (CV)	0.698579509
Kurtosis	5.342466516
Mean	49.77355493
Median Absolute Deviation (MAD)	19.448
Skewness	1.861501106
Sum	17669.612
Variance	1209.007529
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=36)

Value	Count	Frequency (%)
38.896	29	8.2%
24.31	29	8.2%
19.448	29	8.2%
34.034	28	7.9%
48.62	24	6.8%
29.172	22	6.2%
14.586	21	5.9%
43.758	19	5.4%
53.482	18	5.1%
63.206	17	4.8%
Other values (26)	119	33.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4.862	8	2.3%
9.724	10	2.8%
14.586	21	5.9%
19.448	29	8.2%
24.31	29	8.2%
29.172	22	6.2%
34.034	28	7.9%
38.896	29	8.2%
40	1	0.3%
43.758	19	5.4%

Value	Count	Frequency (%)
233.376	2	0.6%
194.48	1	0.3%
175.032	1	0.3%
160.446	1	0.3%
155.584	3	0.8%
150.722	1	0.3%
145.86	1	0.3%
140.998	1	0.3%
131.274	1	0.3%
126.412	1	0.3%

T.H
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	223
Distinct (%)	62.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	387.492008

Minimum	39.99177632
Maximum	1939.703947
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.9 KiB

Quantile statistics

Minimum	39.99177632
5-th percentile	139.9753289
Q1	239.9424342
median	339.9013158
Q3	479.9136514
95-th percentile	785.8610197
Maximum	1939.703947
Range	1899.712171
Interquartile range (IQR)	239.9712172

Descriptive statistics

Standard deviation	227.51835
Coefficient of variation (CV)	0.5871562389
Kurtosis	8.501700232
Mean	387.492008
Median Absolute Deviation (MAD)	119.9506579
Skewness	2.163955716
Sum	137559.6628
Variance	51764.59959
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
259.9342105	7	2.0%
179.9671053	6	1.7%
339.9177632	6	1.7%
219.9506579	5	1.4%
359.9177632	5	1.4%
379.9095395	4	1.1%
159.9588816	4	1.1%
99.97532895	4	1.1%
139.9753289	4	1.1%
319.9506579	4	1.1%
Other values (213)	306	86.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
39.99177632	1	0.3%
59.99177632	1	0.3%
79.97532895	1	0.3%
99.97532895	4	1.1%
99.98355263	3	0.8%
119.9671053	3	0.8%
119.9835526	1	0.3%
139.9588816	1	0.3%
139.9671053	2	0.6%
139.9753289	4	1.1%

Value	Count	Frequency (%)
1939.703947	1	0.3%
1459.671053	1	0.3%
1399.605263	1	0.3%
1319.868421	1	0.3%
1119.736842	1	0.3%
1019.728618	1	0.3%
1019.605263	1	0.3%
979.7779605	1	0.3%
959.7368421	1	0.3%
899.8355263	1	0.3%

SAR
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	351
Distinct (%)	98.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.695397805

Minimum	0.278283756
Maximum	16.7072224
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.9 KiB

Quantile statistics

Minimum	0.278283756
5-th percentile	0.6542491718
Q1	1.315678113
median	2.051581275
Q3	3.11607108
95-th percentile	7.247053391
Maximum	16.7072224
Range	16.42893864
Interquartile range (IQR)	1.800392966

Descriptive statistics

Standard deviation	2.314174552
Coefficient of variation (CV)	0.8585651242
Kurtosis	10.0563283
Mean	2.695397805
Median Absolute Deviation (MAD)	0.822644985
Skewness	2.750662211
Sum	956.8662209
Variance	5.355403855
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.257357044	2	0.6%
1.131686033	2	0.6%
1.475852828	2	0.6%
2.021273363	2	0.6%
2.275366691	1	0.3%
1.63528771	1	0.3%
2.161159576	1	0.3%
4.744374838	1	0.3%
1.934217192	1	0.3%
2.52053183	1	0.3%
Other values (341)	341	96.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.278283756	1	0.3%
0.388916371	1	0.3%
0.388916926	1	0.3%
0.39723036	1	0.3%
0.412513406	1	0.3%
0.481271139	1	0.3%
0.550003737	1	0.3%
0.552308647	1	0.3%
0.55701018	1	0.3%
0.561340405	1	0.3%

Value	Count	Frequency (%)
16.7072224	1	0.3%
15.71039105	1	0.3%
14.00172729	1	0.3%
13.88781532	1	0.3%
11.29978234	1	0.3%
10.56903406	1	0.3%
10.23941103	1	0.3%
9.992544115	1	0.3%
9.808271921	1	0.3%
9.532333618	1	0.3%

Classification
Categorical

HIGH CORRELATION

Distinct	10
Distinct (%)	2.8%
Missing	0
Missing (%)	0.0%
Memory size	2.9 KiB

C3S1	227
C2S1	77
C4S1	17
C3S2	14
C4S2	11
Other values (5)	9

Length

Max length	4
Median length	4
Mean length	3.997183099
Min length	3

Characters and Unicode

Total characters	1419
Distinct characters	9
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	0.3%

Sample

1st row	C3S1
2nd row	C2S1
3rd row	C2S1
4th row	C3S1
5th row	C3S1

Common Values

Value	Count	Frequency (%)
C3S1	227	63.9%
C2S1	77	21.7%
C4S1	17	4.8%
C3S2	14	3.9%
C4S2	11	3.1%
C4S3	2	0.6%
C3S3	2	0.6%
C1S1	2	0.6%
C4S4	2	0.6%
O.G	1	0.3%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
c3s1	227	63.9%
c2s1	77	21.7%
c4s1	17	4.8%
c3s2	14	3.9%
c4s2	11	3.1%
c4s4	2	0.6%
c1s1	2	0.6%
c3s3	2	0.6%
c4s3	2	0.6%
o.g	1	0.3%

Most occurring characters

Value	Count	Frequency (%)
S	354	24.9%
C	354	24.9%
1	325	22.9%
3	247	17.4%
2	102	7.2%
4	34	2.4%
G	1	0.1%
.	1	0.1%
O	1	0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	710	50.0%
Decimal Number	708	49.9%
Other Punctuation	1	0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
S	354	49.9%
C	354	49.9%
G	1	0.1%
O	1	0.1%

Decimal Number

Value	Count	Frequency (%)
1	325	45.9%
3	247	34.9%
2	102	14.4%
4	34	4.8%

Other Punctuation

Value	Count	Frequency (%)
.	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	710	50.0%
Common	709	50.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	325	45.8%
3	247	34.8%
2	102	14.4%
4	34	4.8%
.	1	0.1%

Latin

Value	Count	Frequency (%)
S	354	49.9%
C	354	49.9%
G	1	0.1%
O	1	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1419	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
S	354	24.9%
C	354	24.9%
1	325	22.9%
3	247	17.4%
2	102	7.2%
4	34	2.4%
G	1	0.1%
.	1	0.1%
O	1	0.1%

RSC meq / L
Real number (ℝ)

HIGH CORRELATION

Distinct	295
Distinct (%)	83.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-2.061671145

Minimum	-31.19407895
Maximum	16.60082237
Zeros	0
Zeros (%)	0.0%
Negative	240
Negative (%)	67.6%
Memory size	2.9 KiB

Quantile statistics

Minimum	-31.19407895
5-th percentile	-10.25799342
Q1	-3.597368421
median	-1.398190789
Q3	0.400411184
95-th percentile	2.801891447
Maximum	16.60082237
Range	47.79490132
Interquartile range (IQR)	3.997779605

Descriptive statistics

Standard deviation	4.542889933
Coefficient of variation (CV)	-2.203498819
Kurtosis	7.116617572
Mean	-2.061671145
Median Absolute Deviation (MAD)	1.801480263
Skewness	-1.380914626
Sum	-731.8932566
Variance	20.63784895
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.600986842	3	0.8%
-0.198026316	3	0.8%
-0.998684211	3	0.8%
-1.598355263	3	0.8%
0.800822368	3	0.8%
-1.398848684	3	0.8%
0.201480263	3	0.8%
-0.199013158	3	0.8%
-1.798684211	3	0.8%
-0.797861842	2	0.6%
Other values (285)	326	91.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-31.19407895	1	0.3%
-20.79342105	1	0.3%
-19.39736842	1	0.3%
-18.19210526	1	0.3%
-16.99473684	1	0.3%
-15.59605263	1	0.3%
-15.59457237	1	0.3%
-13.79555921	1	0.3%
-12.396875	1	0.3%
-12.39572368	1	0.3%

Value	Count	Frequency (%)
16.60082237	1	0.3%
11.00098684	1	0.3%
9.800493421	1	0.3%
8.800493421	1	0.3%
8.200657895	1	0.3%
7.400493421	1	0.3%
7.001809211	1	0.3%
5.801480263	1	0.3%
5.601480263	1	0.3%
5.600164474	1	0.3%

Classification.1
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Memory size	2.9 KiB

P.S.	313
U.S.	23
MR	16
M.R	3

Length

Max length	4
Median length	4
Mean length	3.901408451
Min length	2

Characters and Unicode

Total characters	1385
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	P.S.
2nd row	MR
3rd row	P.S.
4th row	P.S.
5th row	P.S.

Common Values

Value	Count	Frequency (%)
P.S.	313	88.2%
U.S.	23	6.5%
MR	16	4.5%
M.R	3	0.8%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
p.s	313	88.2%
u.s	23	6.5%
mr	16	4.5%
m.r	3	0.8%

Most occurring characters

Value	Count	Frequency (%)
.	675	48.7%
S	336	24.3%
P	313	22.6%
U	23	1.7%
R	19	1.4%
M	19	1.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	710	51.3%
Other Punctuation	675	48.7%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
S	336	47.3%
P	313	44.1%
U	23	3.2%
R	19	2.7%
M	19	2.7%

Other Punctuation

Value	Count	Frequency (%)
.	675	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	710	51.3%
Common	675	48.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
S	336	47.3%
P	313	44.1%
U	23	3.2%
R	19	2.7%
M	19	2.7%

Common

Value	Count	Frequency (%)
.	675	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1385	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
.	675	48.7%
S	336	24.3%
P	313	22.6%
U	23	1.7%
R	19	1.4%
M	19	1.4%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	sno	district	mandal	village	temp_id	long_gis	lat_gis	gwl	season	pH	E.C	TDS	CO3	HCO3	Cl	F	NO3	SO4	Na	K	Ca	Mg	T.H	SAR	Classification	RSC meq / L	Classification.1
0	1	ADILABAD	Adilabad	Adilabad	1001	78.524700	19.668300	14.15	Pre-monsoon 2020	7.80	1671.0	1069.44	0	470	230	0.510	3.422409	31.50	154.0	13.00	72	77.792	499.868421	2.994781	C3S1	-0.597368	P.S.
1	2	ADILABAD	Bazarhatnur	Bazarhatnur	1002	78.350833	19.458888	9.35	Pre-monsoon 2020	7.95	545.0	348.80	0	180	80	1.080	4.227682	13.00	94.0	12.00	16	14.586	99.975329	4.087461	C2S1	1.600493	MR
2	3	ADILABAD	Gudihatnoor	Gudihatnoor	1007	78.512222	19.525555	17.50	Pre-monsoon 2020	8.12	738.0	472.32	0	220	30	0.450	28.385864	9.50	22.0	1.00	40	38.896	259.934211	0.593285	C2S1	-0.798684	P.S.
3	4	ADILABAD	Jainath	Jainath	1009	78.640000	19.730555	5.30	Pre-monsoon 2020	8.05	1154.0	738.56	0	300	100	0.690	140.922727	14.75	81.0	3.00	56	68.068	419.884868	1.718668	C3S1	-2.397697	P.S.
4	5	ADILABAD	Narnoor	Narnoor	1010	78.852654	19.495665	4.50	Pre-monsoon 2020	7.17	1042.0	666.88	0	370	30	0.720	163.067727	10.25	39.0	4.00	96	63.206	499.893092	0.758400	C3S1	-2.597862	P.S.
5	6	ADILABAD	Neradigonda	Neradigonda	1011	78.412160	19.293750	9.90	Pre-monsoon 2020	8.09	1063.0	680.32	0	300	100	0.560	62.408636	14.50	65.0	14.00	64	53.482	379.909539	1.449925	C3S1	-1.598191	P.S.
6	7	ADILABAD	Talamadugu	Talamadugu	1013	78.396900	19.633400	8.10	Pre-monsoon 2020	7.94	788.0	504.32	0	310	40	0.440	42.075500	10.50	59.0	4.00	40	43.758	279.925987	1.533213	C3S1	0.601480	P.S.
7	8	ADILABAD	Tamsi	Tamsi	1014	78.426800	19.681100	6.30	Pre-monsoon 2020	8.32	811.0	519.04	20	200	110	0.730	11.475136	16.00	144.0	1.00	16	14.586	99.975329	6.261642	C3S1	2.400493	MR
8	9	ADILABAD	Utnoor	Utnoor	1015	78.768500	19.378900	6.55	Pre-monsoon 2020	7.99	422.0	270.08	0	160	30	0.450	13.488318	8.25	41.0	2.00	24	19.448	139.967105	1.506756	C2S1	0.400658	P.S.
9	10	BHADRADRI	Annapureddypalli	Annapureddypalli	1021	80.826104	17.354519	17.30	Pre-monsoon 2020	8.28	250.0	160.00	0	90	10	0.147	5.314800	6.00	6.4	1.77	24	9.724	99.983553	0.278284	C2S1	-0.199671	P.S.

Last rows

	sno	district	mandal	village	temp_id	long_gis	lat_gis	gwl	season	pH	E.C	TDS	HCO3	Cl	F	NO3	SO4	Na	K	Ca	Mg	T.H	SAR	Classification	RSC meq / L	Classification.1
345	370	YADADRI	Rajapet	Bondugala	1872	78.966500	17.768305	9.80	Pre-monsoon 2020	8.28	1052.0	673.28	260	170	2.22	6.11202	20.0	99.20	2.99	56	43.758	319.925987	2.411343	C3S1	-1.198520	P.S.
346	371	YADADRI	Rajapet	Kurraram	1873	78.929866	17.775490	17.34	Pre-monsoon 2020	7.27	1009.0	645.76	240	130	0.75	65.10630	23.0	55.00	3.35	112	24.310	379.958882	1.226780	C3S1	-2.799178	P.S.
347	372	YADADRI	Rajapet	Rajapet	1875	78.932968	17.729431	7.38	Pre-monsoon 2020	7.22	1408.0	901.12	230	300	1.70	36.93786	19.0	76.47	3.74	136	48.620	539.917763	1.430868	C3S1	-6.198355	P.S.
348	373	YADADRI	Rajapet	Somaram	1876	78.991785	17.725671	16.58	Pre-monsoon 2020	7.66	708.0	453.12	290	40	2.30	14.70428	10.0	43.55	2.77	56	34.034	279.942434	1.131686	C2S1	0.201151	P.S.
349	374	YADADRI	Ramannapet	Ramanapet	1877	79.095091	17.283121	12.60	Pre-monsoon 2020	7.67	3171.0	2029.44	270	890	1.72	35.43200	30.0	215.60	2.50	192	155.584	1119.736842	2.801321	C4S1	-16.994737	P.S.
350	375	YADADRI	S.Narayanpur	S.Narayanpur	1880	78.860010	17.144719	25.90	Pre-monsoon 2020	7.40	2204.0	1410.56	290	300	1.11	436.69940	32.0	148.00	2.00	144	102.102	779.827303	2.304277	C3S1	-9.796546	P.S.
351	376	YADADRI	Thurkapally	Gandamalla	1881	78.853831	17.733101	6.73	Pre-monsoon 2020	7.88	1363.0	872.32	380	170	2.23	35.60916	25.0	119.00	5.39	72	58.344	419.901316	2.524908	C3S1	-0.798026	P.S.
352	377	YADADRI	Valigonda	T. somaram	1883	78.952290	17.399953	13.62	Pre-monsoon 2020	7.66	708.0	453.12	290	40	2.30	14.70428	10.0	43.55	2.77	56	34.034	279.942434	1.131686	C2S1	0.201151	P.S.
353	378	YADADRI	Valigonda	Vemulakonda	1885	79.143433	17.347782	4.07	Pre-monsoon 2020	7.63	4878.0	3121.92	350	1380	0.80	36.89357	105.0	532.00	7.30	400	77.792	1319.868421	6.366760	C4S2	-19.397368	P.S.
354	379	YADADRI	Y.Gutta	Mallapuram	1886	78.911638	17.633555	16.78	Pre-monsoon 2020	7.46	1614.0	1032.96	250	350	1.77	44.99864	22.0	94.00	3.74	152	53.482	599.909539	1.668619	C3S1	-6.998191	P.S.

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Space Separator

Open Punctuation

Close Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Other Punctuation

Open Punctuation

Close Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Space Separator

Other Punctuation

Close Punctuation

Open Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Decimal Number

Space Separator

Dash Punctuation

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category